package com.example.springboot.Mapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.springboot.pojo.SpUser;
import org.apache.ibatis.annotations.*;
import org.springframework.stereotype.Component;

import java.util.List;
//@Mapper
@Component
public interface SpUserMapper extends BaseMapper<SpUser> {


//
//    @Select("select * from sp_user")
//    List<SpUser> All();
//
//    @Insert("INSERT into sys_user(username, password,nickname,email,phone,address) VALUES (#{username}, #{password}," +
//            " #{nickname}, #{email},#{phone}, #{address})")
//    int in(SpUser spUser);
//
//    int update(SpUser spUser);
//
//    @Delete("delete from sp_user where id =#{id}")
//    Integer deleteId(@Param("id") Integer id);

//
//
//   @Select("select * from sp_user where username like #{username} limit  #{Num},#{Size}")
//    List<SpUser> selectPage(Integer Num, Integer Size, String username);
//
//    @Select("select count(*) from sp_user")
//    Integer selectToal();
}
